Stored Procedures [dbo].[BAECartOrderUpdate]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@CartOrderIDint4
@CartItemIDint4
@Quantityint4
@Pricemoney8
@Titlevarchar(128)128
@ProductCodevarchar(64)64
@OrderProductIDint4
SQL Script
create procedure [dbo].[BAECartOrderUpdate] @CartOrderID as
int,
    @CartItemID AS int,
    @Quantity AS int,
    @Price AS money,
    @Title AS varchar(128),
    @ProductCode AS varchar(64),
    @OrderProductID AS int
AS
    UPDATE CartOrder
    SET CartItemID = @CartItemID,
    Quantity = @Quantity,
    Price = @Price,
    Title = @Title,
    ProductCode = @ProductCode,
    OrderProductID = @OrderProductID
    WHERE CartOrderID = @CartOrderID;

GO
Uses